﻿CREATE TABLE [dbo].[StockGroups-Stocks]
(
	IdStockGroup smallint NOT NULL CONSTRAINT ForeignStockGroupsId FOREIGN KEY REFERENCES StockGroups (Id), 
	IdStock smallint NOT NULL CONSTRAINT ForeignIdStock FOREIGN KEY REFERENCES Stocks (Id), 
	DateAdded smalldatetime NOT NULL,
	DateRemoved smalldatetime NULL
	CONSTRAINT [StockGroups-StocksKey] PRIMARY KEY (IdStockGroup,IdStock,DateAdded)
)
